CREATE TABLE [dbo].[Interest_Category]
(
[InterestCategoryID] [numeric] (18, 0) NOT NULL IDENTITY(1, 1),
[Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IndustryFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SICCode] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentCategoryID] [numeric] (18, 0) NULL,
[AncestorCategoryID] [numeric] (18, 0) NULL,
[CategoryDepth] [numeric] (18, 0) NULL,
[AncestorOrder] [numeric] (28, 18) NULL,
[SortOrder] [numeric] (28, 18) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Interest_Category] ADD CONSTRAINT [PK_Interest_Category] PRIMARY KEY CLUSTERED ([InterestCategoryID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CATEGORY_PARENT2] ON [dbo].[Interest_Category] ([ParentCategoryID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Interest_Category] TO [IMIS]
GRANT SELECT ON  [dbo].[Interest_Category] TO [IMIS]
GRANT INSERT ON  [dbo].[Interest_Category] TO [IMIS]
GRANT DELETE ON  [dbo].[Interest_Category] TO [IMIS]
GRANT UPDATE ON  [dbo].[Interest_Category] TO [IMIS]
GO